<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"> <style>
	.KEYW {color: #933;}
	.COMM {color: #bbb; font-style: italic;}
	.NUMB {color: #393;}
	.STRN {color: #393;}
	.REGX {color: #339;}
	.line {border-right: 1px dotted #666; color: #666; font-style: normal;}
	</style></head><body><pre><span class='line'>  1</span> <span class="PUNC">;</span><span class="COMM">/**
<span class='line'>  2</span>  * @fileOverview DB Class
<span class='line'>  3</span>  * @author &lt;a href="http://ngsdev.org/">Atsushi Nagase &lt;/a>
<span class='line'>  4</span>  * @license &lt;a href="http://www.apache.org/licenses/LICENSE-2.0">Apache License 2.0&lt;/a>
<span class='line'>  5</span>  * @global DBClass
<span class='line'>  6</span>  */</span><span class="WHIT">
<span class='line'>  7</span> 
<span class='line'>  8</span> </span><span class="COMM">/** @static
<span class='line'>  9</span>  * @class */</span><span class="WHIT">
<span class='line'> 10</span> </span><span class="NAME">DBClass.Adapter</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'> 11</span> 	</span><span class="COMM">/** @member
<span class='line'> 12</span> 	 * @constant */</span><span class="WHIT">
<span class='line'> 13</span> 	</span><span class="NAME">HTML5</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="STRN">"html5"</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'> 14</span> 	</span><span class="COMM">/** @member
<span class='line'> 15</span> 	 * @constant */</span><span class="WHIT">
<span class='line'> 16</span> 	</span><span class="NAME">GEARS</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="STRN">"gears"</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'> 17</span> 	</span><span class="COMM">/** @member
<span class='line'> 18</span> 	 * @constant */</span><span class="WHIT">
<span class='line'> 19</span> 	</span><span class="NAME">YAHOO</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="STRN">"yahoo"</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'> 20</span> 	</span><span class="COMM">/** @member
<span class='line'> 21</span> 	 * @constant */</span><span class="WHIT">
<span class='line'> 22</span> 	</span><span class="NAME">AIR</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="STRN">"air"</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'> 23</span> 	</span><span class="COMM">/** @member
<span class='line'> 24</span> 	 * @constant */</span><span class="WHIT">
<span class='line'> 25</span> 	</span><span class="NAME">AUTO</span><span class="WHIT">  </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="STRN">"auto"</span><span class="WHIT">
<span class='line'> 26</span> </span><span class="PUNC">}</span><span class="WHIT">
<span class='line'> 27</span>  
<span class='line'> 28</span> </span><span class="COMM">/**
<span class='line'> 29</span>  * @class
<span class='line'> 30</span>  * @constructor
<span class='line'> 31</span>  */</span><span class="WHIT">
<span class='line'> 32</span> </span><span class="KEYW">function</span><span class="WHIT"> </span><span class="NAME">DBClass</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'> 33</span> 	</span><span class="KEYW">throw</span><span class="WHIT"> </span><span class="NAME">Error</span><span class="PUNC">(</span><span class="STRN">"DBClass has no constructor"</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 34</span> </span><span class="PUNC">}</span><span class="WHIT">
<span class='line'> 35</span> 
<span class='line'> 36</span> </span><span class="COMM">/**
<span class='line'> 37</span>  * @static
<span class='line'> 38</span>  * @function
<span class='line'> 39</span>  * @param {String} name Database name or Path to database(Yahoo).
<span class='line'> 40</span>  * @param {int} type Database size; If Yahoo,this will be ignored.
<span class='line'> 41</span>  * @param {DBClass.Adapter} type Database type; If Yahoo, this will be ignored.
<span class='line'> 42</span>  * @param {String} version Database version; If Yahoo, this will be ignored.
<span class='line'> 43</span>  * @param {String} comment Database comment; If Yahoo, this will be ignored.
<span class='line'> 44</span>  */</span><span class="WHIT">
<span class='line'> 45</span> </span><span class="NAME">DBClass.create</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">name</span><span class="PUNC">,</span><span class="NAME">size</span><span class="PUNC">,</span><span class="NAME">type</span><span class="PUNC">,</span><span class="NAME">version</span><span class="PUNC">,</span><span class="NAME">comment</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'> 46</span> 	</span><span class="KEYW">if</span><span class="PUNC">(</span><span class="PUNC">!</span><span class="NAME">name</span><span class="PUNC">)</span><span class="WHIT">  </span><span class="KEYW">throw</span><span class="WHIT"> </span><span class="NAME">Error</span><span class="PUNC">(</span><span class="STRN">"Parameter:name is required."</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 47</span> 	</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">c</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'> 48</span> 		</span><span class="NAME">this.name</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">name</span><span class="PUNC">||</span><span class="NAME">this.name</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 49</span> 		</span><span class="NAME">this.size</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">size</span><span class="PUNC">||</span><span class="NAME">this.size</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 50</span> 		</span><span class="NAME">this.type</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">type</span><span class="PUNC">||</span><span class="NAME">this.type</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 51</span> 		</span><span class="NAME">this.version</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">version</span><span class="PUNC">||</span><span class="NAME">this.vertion</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 52</span> 		</span><span class="NAME">this.comment</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">this.comment</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 53</span> 		</span><span class="NAME">this.db</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">DBClass.detectDB</span><span class="PUNC">(</span><span class="KEYW">this</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 54</span> 	</span><span class="PUNC">}</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 55</span> 	</span><span class="NAME">c.prototype</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">DBClass.prototype</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 56</span> 	</span><span class="KEYW">return</span><span class="WHIT"> </span><span class="NAME">c</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 57</span> </span><span class="PUNC">}</span><span class="WHIT">
<span class='line'> 58</span> 
<span class='line'> 59</span> </span><span class="COMM">/**
<span class='line'> 60</span>  * @private
<span class='line'> 61</span>  * @static
<span class='line'> 62</span>  */</span><span class="WHIT">
<span class='line'> 63</span> </span><span class="NAME">DBClass.detectDB</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">ins</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'> 64</span> 	</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">db</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 65</span> 	</span><span class="KEYW">switch</span><span class="PUNC">(</span><span class="NAME">ins.type</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'> 66</span> 	</span><span class="KEYW">case</span><span class="WHIT"> </span><span class="NAME">DBClass.Adapter.HTML5</span><span class="PUNC">:</span><span class="WHIT">
<span class='line'> 67</span> 		</span><span class="NAME">db</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">openDatabase</span><span class="PUNC">(</span><span class="NAME">ins.name</span><span class="PUNC">,</span><span class="WHIT"> </span><span class="NAME">ins.version</span><span class="PUNC">,</span><span class="WHIT"> </span><span class="NAME">ins.comment</span><span class="PUNC">,</span><span class="WHIT"> </span><span class="NAME">ins.size</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 68</span> 		</span><span class="KEYW">return</span><span class="WHIT"> </span><span class="NAME">db</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 69</span> 		</span><span class="KEYW">break</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 70</span> 	</span><span class="KEYW">case</span><span class="WHIT"> </span><span class="NAME">DBClass.Adapter.GEARS</span><span class="PUNC">:</span><span class="WHIT">
<span class='line'> 71</span> 		</span><span class="NAME">db</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">google.gears.factory.create</span><span class="PUNC">(</span><span class="STRN">"beta.database"</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 72</span> 		</span><span class="NAME">db.open</span><span class="PUNC">(</span><span class="NAME">ins.name</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 73</span> 		</span><span class="KEYW">return</span><span class="WHIT"> </span><span class="NAME">db</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 74</span> 		</span><span class="KEYW">break</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 75</span> 	</span><span class="KEYW">case</span><span class="WHIT"> </span><span class="NAME">DBClass.Adapter.YAHOO</span><span class="PUNC">:</span><span class="WHIT">
<span class='line'> 76</span> 		</span><span class="NAME">db</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">SQLite</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 77</span> 		</span><span class="NAME">db.open</span><span class="PUNC">(</span><span class="NAME">ins.name</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 78</span> 		</span><span class="KEYW">return</span><span class="WHIT"> </span><span class="NAME">db</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 79</span> 		</span><span class="KEYW">break</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 80</span> 	</span><span class="KEYW">case</span><span class="WHIT"> </span><span class="NAME">DBClass.Adapter.AIR</span><span class="PUNC">:</span><span class="WHIT">
<span class='line'> 81</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">f</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">air.File</span><span class="PUNC">(</span><span class="STRN">"app-storage:/"</span><span class="PUNC">+</span><span class="NAME">ins.name</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 82</span> 		</span><span class="NAME">db</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'> 83</span> 			</span><span class="NAME">file</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="NAME">f</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'> 84</span> 			</span><span class="NAME">connection</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">air.SQLConnection</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="WHIT">
<span class='line'> 85</span> 		</span><span class="PUNC">}</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 86</span> 		</span><span class="KEYW">return</span><span class="WHIT"> </span><span class="NAME">db</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 87</span> 		</span><span class="KEYW">break</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 88</span> 	</span><span class="KEYW">case</span><span class="WHIT"> </span><span class="NAME">DBClass.Adapter.AUTO</span><span class="PUNC">:</span><span class="WHIT">
<span class='line'> 89</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">e</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 90</span> 		</span><span class="KEYW">for</span><span class="PUNC">(</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">i</span><span class="WHIT"> </span><span class="KEYW">in</span><span class="WHIT"> </span><span class="NAME">DBClass.Adapter</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'> 91</span> 			</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">t</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">DBClass.Adapter</span><span class="PUNC">[</span><span class="NAME">i</span><span class="PUNC">]</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 92</span> 			</span><span class="KEYW">if</span><span class="PUNC">(</span><span class="NAME">t</span><span class="PUNC">==</span><span class="NAME">DBClass.Adapter.AUTO</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="KEYW">continue</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 93</span> 			</span><span class="KEYW">try</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'> 94</span> 				</span><span class="NAME">ins.type</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">t</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 95</span> 				</span><span class="NAME">db</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">DBClass.detectDB</span><span class="PUNC">(</span><span class="NAME">ins</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 96</span> 				</span><span class="KEYW">if</span><span class="PUNC">(</span><span class="NAME">db</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="KEYW">return</span><span class="WHIT"> </span><span class="NAME">db</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'> 97</span> 			</span><span class="PUNC">}</span><span class="WHIT"> </span><span class="KEYW">catch</span><span class="PUNC">(</span><span class="NAME">e</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'> 98</span> 		</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'> 99</span> 		</span><span class="KEYW">throw</span><span class="WHIT"> </span><span class="NAME">Error</span><span class="PUNC">(</span><span class="STRN">"Database is not supported."</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>100</span> 		</span><span class="KEYW">break</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>101</span> 	</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>102</span> </span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>103</span> 
<span class='line'>104</span> </span><span class="COMM">/** @class */</span><span class="WHIT">
<span class='line'>105</span> </span><span class="NAME">DBClass.prototype</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>106</span> 	</span><span class="COMM">/**
<span class='line'>107</span> 	 * Database name or database filename.
<span class='line'>108</span> 	 * @type String
<span class='line'>109</span> 	 */</span><span class="WHIT">
<span class='line'>110</span> 	</span><span class="NAME">name</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="STRN">""</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>111</span> 	</span><span class="COMM">/**
<span class='line'>112</span> 	 * Database size; If not HTML5, this will be ignored.
<span class='line'>113</span> 	 * @type int
<span class='line'>114</span> 	 * @default 200000
<span class='line'>115</span> 	 */</span><span class="WHIT">
<span class='line'>116</span> 	</span><span class="NAME">size</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="NUMB">200000</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>117</span> 	</span><span class="COMM">/**
<span class='line'>118</span> 	 * Database type; If not HTML5, this will be ignored.
<span class='line'>119</span> 	 * @type DBClass.Adapter
<span class='line'>120</span> 	 * @default DBClass.Adapter.AUTO
<span class='line'>121</span> 	 */</span><span class="WHIT">
<span class='line'>122</span> 	</span><span class="NAME">type</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="NAME">DBClass.Adapter.AUTO</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>123</span> 	</span><span class="COMM">/**
<span class='line'>124</span> 	 * Database version; If not HTML5, this will be ignored.
<span class='line'>125</span> 	 * @type String
<span class='line'>126</span> 	 * @default 1.0
<span class='line'>127</span> 	 */</span><span class="WHIT">
<span class='line'>128</span> 	</span><span class="NAME">verion</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="STRN">"1.0"</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>129</span> 	</span><span class="COMM">/**
<span class='line'>130</span> 	 * Database comment; If not HTML5, this will be ignored.
<span class='line'>131</span> 	 * @type String
<span class='line'>132</span> 	 * @default Uncommented database generated by DBClass.js
<span class='line'>133</span> 	 */</span><span class="WHIT">
<span class='line'>134</span> 	</span><span class="NAME">comment</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="STRN">"Uncommented database generated by DBClass.js"</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>135</span> 	</span><span class="COMM">/**
<span class='line'>136</span> 	 * Database instance.
<span class='line'>137</span> 	 * @type Object
<span class='line'>138</span> 	 */</span><span class="WHIT">
<span class='line'>139</span> 	</span><span class="NAME">db</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">null</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>140</span> 	</span><span class="COMM">/**
<span class='line'>141</span> 	 * @param {String} table Table name.
<span class='line'>142</span> 	 * @param {Array.&lt;AbstractSQL.Field&gt;} fields Array contains AbstractSQL.Field class instances.
<span class='line'>143</span> 	 * @returns DBClass.Schema
<span class='line'>144</span> 	 * @param {Boolean} createManually
<span class='line'>145</span> 	 */</span><span class="WHIT">
<span class='line'>146</span> 	</span><span class="NAME">schema</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">table</span><span class="PUNC">,</span><span class="NAME">fields</span><span class="PUNC">,</span><span class="NAME">createManually</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>147</span> 		</span><span class="KEYW">return</span><span class="WHIT"> </span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">DBClass.Schema</span><span class="PUNC">(</span><span class="KEYW">this</span><span class="PUNC">,</span><span class="NAME">table</span><span class="PUNC">,</span><span class="NAME">fields</span><span class="PUNC">,</span><span class="NAME">createManually</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>148</span> 	</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>149</span> </span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>150</span> 
<span class='line'>151</span> </span><span class="COMM">/**
<span class='line'>152</span>  * @class
<span class='line'>153</span>  * @constructor
<span class='line'>154</span>  * @param {DBClass} db
<span class='line'>155</span>  * @param {String} name Table name.
<span class='line'>156</span>  * @param {Array.&lt;AbstractSQL.Field&gt;} fields Array contains AbstractSQL.Field class instances.
<span class='line'>157</span>  * @param {Boolean} createManually
<span class='line'>158</span>  */</span><span class="WHIT">
<span class='line'>159</span> </span><span class="NAME">DBClass.Schema</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">db</span><span class="PUNC">,</span><span class="NAME">name</span><span class="PUNC">,</span><span class="NAME">fields</span><span class="PUNC">,</span><span class="NAME">createManually</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>160</span> 	</span><span class="NAME">this.name</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">name</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>161</span> 	</span><span class="NAME">this.db</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">db</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>162</span> 	</span><span class="NAME">this.fields</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">fields</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>163</span> 	</span><span class="NAME">this.createManually</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="PUNC">!</span><span class="PUNC">!</span><span class="NAME">createManually</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>164</span> </span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>165</span> 
<span class='line'>166</span> </span><span class="COMM">/** @class */</span><span class="WHIT">
<span class='line'>167</span> </span><span class="NAME">DBClass.Schema.prototype</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>168</span> 	</span><span class="COMM">/**
<span class='line'>169</span> 	 * Initialize Schema
<span class='line'>170</span> 	 * @param {Function} callback
<span class='line'>171</span> 	 */</span><span class="WHIT">
<span class='line'>172</span> 	</span><span class="NAME">init</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">callback</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>173</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">sql</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">AbstractSQL</span><span class="PUNC">(</span><span class="NAME">this.name</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>174</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">schema</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">this</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>175</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">db</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">schema.db.db</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>176</span> 		</span><span class="NAME">callback</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">callback</span><span class="WHIT"> </span><span class="PUNC">||</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="PUNC">}</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>177</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">f</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>178</span> 			</span><span class="KEYW">if</span><span class="PUNC">(</span><span class="PUNC">!</span><span class="NAME">schema.createManually</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>179</span> 				</span><span class="NAME">schema.exec</span><span class="PUNC">(</span><span class="NAME">sql.createTable</span><span class="PUNC">(</span><span class="NAME">schema.fields</span><span class="PUNC">,</span><span class="KEYW">true</span><span class="PUNC">,</span><span class="KEYW">false</span><span class="PUNC">)</span><span class="PUNC">,</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>180</span> 					</span><span class="NAME">callback.apply</span><span class="PUNC">(</span><span class="NAME">schema</span><span class="PUNC">,</span><span class="PUNC">[</span><span class="KEYW">this</span><span class="PUNC">]</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>181</span> 				</span><span class="PUNC">}</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>182</span> 			</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>183</span> 		</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>184</span> 		</span><span class="KEYW">if</span><span class="PUNC">(</span><span class="NAME">schema.db.type</span><span class="PUNC">==</span><span class="NAME">DBClass.Adapter.AIR</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>185</span> 			</span><span class="NAME">db.connection.addEventListener</span><span class="PUNC">(</span><span class="NAME">air.SQLEvent.OPEN</span><span class="PUNC">,</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">e</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>186</span> 				</span><span class="NAME">f</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>187</span> 			</span><span class="PUNC">}</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>188</span> 			</span><span class="NAME">db.connection.addEventListener</span><span class="PUNC">(</span><span class="NAME">air.SQLErrorEvent.ERROR</span><span class="PUNC">,</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">e</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>189</span> 				</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">res</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">DBClass.Result</span><span class="PUNC">(</span><span class="KEYW">null</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>190</span> 				</span><span class="NAME">res.success</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">false</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>191</span> 				</span><span class="NAME">res.error</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">e.error</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>192</span> 				</span><span class="NAME">callback.apply</span><span class="PUNC">(</span><span class="NAME">schema</span><span class="PUNC">,</span><span class="PUNC">[</span><span class="NAME">res</span><span class="PUNC">]</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>193</span> 			</span><span class="PUNC">}</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>194</span> 			</span><span class="NAME">db.connection.openAsync</span><span class="PUNC">(</span><span class="NAME">db.file</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>195</span> 		</span><span class="PUNC">}</span><span class="WHIT"> </span><span class="KEYW">else</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>196</span> 			</span><span class="NAME">f</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>197</span> 		</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>198</span> 	</span><span class="PUNC">}</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>199</span> 	</span><span class="COMM">/**
<span class='line'>200</span> 	 * If true, don't create table automatic.
<span class='line'>201</span> 	 * @type Boolean
<span class='line'>202</span> 	 */</span><span class="WHIT">
<span class='line'>203</span> 	</span><span class="NAME">createManually</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">false</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>204</span> 	</span><span class="COMM">/**
<span class='line'>205</span> 	 * Table name
<span class='line'>206</span> 	 * @type String
<span class='line'>207</span> 	 */</span><span class="WHIT">
<span class='line'>208</span> 	</span><span class="NAME">name</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="STRN">""</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>209</span> 	</span><span class="COMM">/**
<span class='line'>210</span> 	 * Array contains AbstractSQL.Field class instances.
<span class='line'>211</span> 	 * @type Array.&lt;AbstractSQL.Field&gt;
<span class='line'>212</span> 	 */</span><span class="WHIT">
<span class='line'>213</span> 	</span><span class="NAME">fields</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">null</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>214</span> 	</span><span class="COMM">/**
<span class='line'>215</span> 	 * Execute SQL
<span class='line'>216</span> 	 * @param {AbstractSQL} sql First callback argument in DBClass.Result instance.
<span class='line'>217</span> 	 * @param {Function} callback
<span class='line'>218</span> 	 * @param {Array.&lt;String>} bind Bind Variables; Not supported in Yahoo
<span class='line'>219</span> 	 */</span><span class="WHIT">
<span class='line'>220</span> 	</span><span class="NAME">exec</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">sql</span><span class="PUNC">,</span><span class="NAME">callback</span><span class="PUNC">,</span><span class="NAME">bind</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>221</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">schema</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">this</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>222</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">isSelect</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">RegExp</span><span class="PUNC">(</span><span class="STRN">"^select .+"</span><span class="PUNC">,</span><span class="STRN">"i"</span><span class="PUNC">)</span><span class="PUNC">.</span><span class="NAME">test</span><span class="PUNC">(</span><span class="NAME">sql</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>223</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">db</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">schema.db.db</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>224</span> 		</span><span class="NAME">callback</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">callback</span><span class="WHIT"> </span><span class="PUNC">||</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="PUNC">}</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>225</span> 		</span><span class="NAME">bind</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">bind</span><span class="PUNC">||</span><span class="PUNC">[</span><span class="PUNC">]</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>226</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">callbackError</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">err</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>227</span> 			</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">res</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">DBClass.Result</span><span class="PUNC">(</span><span class="KEYW">null</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>228</span> 			</span><span class="NAME">res.success</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">false</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>229</span> 			</span><span class="NAME">res.sql</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">sql</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>230</span> 			</span><span class="NAME">res.error</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">err</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>231</span> 			</span><span class="NAME">callback.apply</span><span class="PUNC">(</span><span class="NAME">res</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>232</span> 		</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>233</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">callbackSuccess</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">each</span><span class="PUNC">,</span><span class="NAME">item</span><span class="PUNC">,</span><span class="NAME">length</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>234</span> 			</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">res</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">DBClass.Result</span><span class="PUNC">(</span><span class="NAME">isSelect</span><span class="PUNC">?</span><span class="NAME">r</span><span class="PUNC">:</span><span class="KEYW">null</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>235</span> 			</span><span class="KEYW">if</span><span class="PUNC">(</span><span class="NAME">isSelect</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>236</span> 				</span><span class="NAME">res.each</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">each</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>237</span> 				</span><span class="NAME">res.item</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">item</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>238</span> 				</span><span class="NAME">res.length</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">length</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>239</span> 			</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>240</span> 			</span><span class="NAME">res.success</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">true</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>241</span> 			</span><span class="NAME">res.sql</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">sql</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>242</span> 			</span><span class="NAME">callback.apply</span><span class="PUNC">(</span><span class="NAME">res</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>243</span> 		</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>244</span> 		</span><span class="KEYW">switch</span><span class="PUNC">(</span><span class="NAME">schema.db.type</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>245</span> 		</span><span class="KEYW">case</span><span class="WHIT"> </span><span class="NAME">DBClass.Adapter.YAHOO</span><span class="PUNC">:</span><span class="WHIT">
<span class='line'>246</span> 			</span><span class="KEYW">try</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>247</span> 				</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">r</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">isSelect</span><span class="PUNC">?</span><span class="NAME">db.query</span><span class="PUNC">(</span><span class="NAME">sql</span><span class="PUNC">)</span><span class="PUNC">:</span><span class="NAME">db.exec</span><span class="PUNC">(</span><span class="NAME">sql</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>248</span> 				</span><span class="KEYW">if</span><span class="PUNC">(</span><span class="PUNC">!</span><span class="NAME">r</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="KEYW">return</span><span class="WHIT"> </span><span class="NAME">callbackError</span><span class="PUNC">(</span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">Error</span><span class="PUNC">(</span><span class="STRN">"No result."</span><span class="PUNC">)</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>249</span> 				</span><span class="KEYW">if</span><span class="PUNC">(</span><span class="NAME">isSelect</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>250</span> 					</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">rows</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">r.getAll</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>251</span> 					</span><span class="NAME">callbackSuccess</span><span class="PUNC">(</span><span class="WHIT">
<span class='line'>252</span> 						</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">cb</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>253</span> 							</span><span class="KEYW">for</span><span class="PUNC">(</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">i</span><span class="PUNC">=</span><span class="NUMB">0</span><span class="PUNC">;</span><span class="NAME">i</span><span class="PUNC">&lt;</span><span class="NAME">rows.length</span><span class="PUNC">;</span><span class="NAME">i</span><span class="PUNC">++</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>254</span> 								</span><span class="NAME">cb.apply</span><span class="PUNC">(</span><span class="NAME">this.item</span><span class="PUNC">(</span><span class="NAME">i</span><span class="PUNC">)</span><span class="PUNC">,</span><span class="PUNC">[</span><span class="NAME">i</span><span class="PUNC">,</span><span class="KEYW">this</span><span class="PUNC">]</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>255</span> 							</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>256</span> 						</span><span class="PUNC">}</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>257</span> 						</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">idx</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT"> </span><span class="KEYW">return</span><span class="WHIT"> </span><span class="NAME">rows</span><span class="PUNC">[</span><span class="NAME">idx</span><span class="PUNC">]</span><span class="PUNC">;</span><span class="WHIT"> </span><span class="PUNC">}</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>258</span> 						</span><span class="NAME">rows.length</span><span class="WHIT">
<span class='line'>259</span> 					</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>260</span> 					</span><span class="KEYW">return</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>261</span> 				</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>262</span> 				</span><span class="NAME">callbackSuccess</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>263</span> 				</span><span class="KEYW">return</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>264</span> 			</span><span class="PUNC">}</span><span class="WHIT"> </span><span class="KEYW">catch</span><span class="PUNC">(</span><span class="NAME">err</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>265</span> 				</span><span class="NAME">callbackError</span><span class="PUNC">(</span><span class="NAME">err</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>266</span> 				</span><span class="KEYW">return</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>267</span> 			</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>268</span> 			</span><span class="NAME">callbackError</span><span class="PUNC">(</span><span class="NAME">err</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>269</span> 			</span><span class="KEYW">return</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>270</span> 		</span><span class="KEYW">case</span><span class="WHIT"> </span><span class="NAME">DBClass.Adapter.AIR</span><span class="PUNC">:</span><span class="WHIT">
<span class='line'>271</span> 			</span><span class="KEYW">if</span><span class="PUNC">(</span><span class="PUNC">!</span><span class="NAME">db.connection.connected</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="KEYW">return</span><span class="WHIT"> </span><span class="NAME">callbackError</span><span class="PUNC">(</span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">Error</span><span class="PUNC">(</span><span class="STRN">"Not connected."</span><span class="PUNC">)</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>272</span> 			</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">stmt</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">air.SQLStatement</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>273</span> 			</span><span class="NAME">stmt.sqlConnection</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">db.connection</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>274</span> 			</span><span class="NAME">stmt.addEventListener</span><span class="PUNC">(</span><span class="NAME">air.SQLEvent.RESULT</span><span class="PUNC">,</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">e</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>275</span> 				
<span class='line'>276</span> 			</span><span class="PUNC">}</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>277</span> 			</span><span class="NAME">stmt.addEventListener</span><span class="PUNC">(</span><span class="NAME">air.SQLErrorEvent.ERROR</span><span class="PUNC">,</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">e</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>278</span> 				</span><span class="NAME">callbackError</span><span class="PUNC">(</span><span class="NAME">e.error</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>279</span> 			</span><span class="PUNC">}</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>280</span> 			</span><span class="NAME">stmt.text</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">sql.toString</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>281</span> 			</span><span class="NAME">stmt.execute</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>282</span> 			</span><span class="KEYW">return</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>283</span> 		</span><span class="KEYW">case</span><span class="WHIT"> </span><span class="NAME">DBClass.Adapter.GEARS</span><span class="PUNC">:</span><span class="WHIT">
<span class='line'>284</span> 			</span><span class="KEYW">try</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>285</span> 				</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">r</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">db.execute</span><span class="PUNC">(</span><span class="NAME">sql</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>286</span> 				</span><span class="KEYW">if</span><span class="PUNC">(</span><span class="NAME">isSelect</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>287</span> 					</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">ar</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="PUNC">[</span><span class="PUNC">]</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>288</span> 					</span><span class="KEYW">while</span><span class="PUNC">(</span><span class="NAME">r.isValidRow</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>289</span> 						</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">itm</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="PUNC">}</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>290</span> 						</span><span class="KEYW">for</span><span class="PUNC">(</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">i</span><span class="PUNC">=</span><span class="NUMB">0</span><span class="PUNC">;</span><span class="NAME">i</span><span class="PUNC">&lt;</span><span class="NAME">r.fieldCount</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="NAME">i</span><span class="PUNC">++</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>291</span> 							</span><span class="NAME">itm</span><span class="PUNC">[</span><span class="NAME">r.fieldName</span><span class="PUNC">(</span><span class="NAME">i</span><span class="PUNC">)</span><span class="PUNC">]</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">r.field</span><span class="PUNC">(</span><span class="NAME">i</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>292</span> 						</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>293</span> 						</span><span class="NAME">ar.push</span><span class="PUNC">(</span><span class="NAME">itm</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>294</span> 						</span><span class="NAME">r.next</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>295</span> 					</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>296</span> 					</span><span class="NAME">r.close</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>297</span> 					</span><span class="NAME">callbackSuccess</span><span class="PUNC">(</span><span class="WHIT">
<span class='line'>298</span> 						</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">cb</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>299</span> 							</span><span class="KEYW">for</span><span class="PUNC">(</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">i</span><span class="PUNC">=</span><span class="NUMB">0</span><span class="PUNC">;</span><span class="NAME">i</span><span class="PUNC">&lt;</span><span class="NAME">ar.length</span><span class="PUNC">;</span><span class="NAME">i</span><span class="PUNC">++</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>300</span> 								</span><span class="NAME">cb.apply</span><span class="PUNC">(</span><span class="NAME">this.item</span><span class="PUNC">(</span><span class="NAME">i</span><span class="PUNC">)</span><span class="PUNC">,</span><span class="PUNC">[</span><span class="NAME">i</span><span class="PUNC">,</span><span class="KEYW">this</span><span class="PUNC">]</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>301</span> 							</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>302</span> 						</span><span class="PUNC">}</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>303</span> 						</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">idx</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT"> </span><span class="KEYW">return</span><span class="WHIT"> </span><span class="NAME">ar</span><span class="PUNC">[</span><span class="NAME">idx</span><span class="PUNC">]</span><span class="PUNC">;</span><span class="WHIT"> </span><span class="PUNC">}</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>304</span> 						</span><span class="NAME">ar.length</span><span class="WHIT">
<span class='line'>305</span> 					</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>306</span> 					</span><span class="KEYW">return</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>307</span> 					
<span class='line'>308</span> 				</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>309</span> 				</span><span class="KEYW">if</span><span class="PUNC">(</span><span class="NAME">r</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>310</span> 					</span><span class="NAME">r.close</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>311</span> 					</span><span class="NAME">callbackSuccess</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>312</span> 					</span><span class="KEYW">return</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>313</span> 				</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>314</span> 			</span><span class="PUNC">}</span><span class="WHIT"> </span><span class="KEYW">catch</span><span class="PUNC">(</span><span class="NAME">e</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>315</span> 				</span><span class="NAME">callbackError</span><span class="PUNC">(</span><span class="NAME">e</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>316</span> 				</span><span class="KEYW">return</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>317</span> 			</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>318</span> 			</span><span class="NAME">callbackError</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>319</span> 			</span><span class="KEYW">return</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>320</span> 		</span><span class="KEYW">default</span><span class="PUNC">:</span><span class="WHIT">
<span class='line'>321</span> 			</span><span class="NAME">db.transaction</span><span class="PUNC">(</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">tx</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>322</span> 				</span><span class="NAME">tx.executeSql</span><span class="PUNC">(</span><span class="NAME">sql</span><span class="PUNC">,</span><span class="NAME">bind</span><span class="PUNC">,</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">tx</span><span class="PUNC">,</span><span class="NAME">r</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>323</span> 					</span><span class="KEYW">if</span><span class="PUNC">(</span><span class="NAME">isSelect</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>324</span> 						</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">rows</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">r.rows</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>325</span> 						</span><span class="NAME">callbackSuccess</span><span class="PUNC">(</span><span class="WHIT">
<span class='line'>326</span> 							</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">cb</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>327</span> 								</span><span class="KEYW">for</span><span class="PUNC">(</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">i</span><span class="PUNC">=</span><span class="NUMB">0</span><span class="PUNC">;</span><span class="NAME">i</span><span class="PUNC">&lt;</span><span class="NAME">rows.length</span><span class="PUNC">;</span><span class="NAME">i</span><span class="PUNC">++</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>328</span> 									</span><span class="NAME">cb.apply</span><span class="PUNC">(</span><span class="NAME">rows.item</span><span class="PUNC">(</span><span class="NAME">i</span><span class="PUNC">)</span><span class="PUNC">,</span><span class="PUNC">[</span><span class="NAME">i</span><span class="PUNC">,</span><span class="KEYW">this</span><span class="PUNC">]</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>329</span> 								</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>330</span> 							</span><span class="PUNC">}</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>331</span> 							</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">idx</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT"> </span><span class="KEYW">return</span><span class="WHIT"> </span><span class="NAME">rows.item</span><span class="PUNC">(</span><span class="NAME">idx</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT"> </span><span class="PUNC">}</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>332</span> 							</span><span class="NAME">rows.length</span><span class="WHIT">
<span class='line'>333</span> 						</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>334</span> 						</span><span class="KEYW">return</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>335</span> 					</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>336</span> 					</span><span class="NAME">callbackSuccess</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>337</span> 					</span><span class="KEYW">return</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>338</span> 				</span><span class="PUNC">}</span><span class="PUNC">,</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">tx</span><span class="PUNC">,</span><span class="NAME">err</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>339</span> 					</span><span class="NAME">callbackError</span><span class="PUNC">(</span><span class="NAME">err</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>340</span> 					</span><span class="KEYW">return</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>341</span> 				</span><span class="PUNC">}</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>342</span> 			</span><span class="PUNC">}</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>343</span> 			</span><span class="KEYW">return</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>344</span> 		</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>345</span> 	</span><span class="PUNC">}</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>346</span> 	</span><span class="COMM">/**
<span class='line'>347</span> 	 * Select rows
<span class='line'>348</span> 	 * @param {Array.&lt;String&gt;} fields
<span class='line'>349</span> 	 * @param {AbstractSQL.Where|AbstractSQL.WhereList} where
<span class='line'>350</span> 	 * @param {int} limit
<span class='line'>351</span> 	 * @param {AbstractSQL.Order} order
<span class='line'>352</span> 	 * @param {Function} callback
<span class='line'>353</span> 	 */</span><span class="WHIT">
<span class='line'>354</span> 	</span><span class="NAME">select</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">fields</span><span class="PUNC">,</span><span class="NAME">where</span><span class="PUNC">,</span><span class="NAME">limit</span><span class="PUNC">,</span><span class="NAME">order</span><span class="PUNC">,</span><span class="NAME">callback</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>355</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">sql</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">AbstractSQL</span><span class="PUNC">(</span><span class="NAME">this.name</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>356</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">schema</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">this</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>357</span> 		</span><span class="NAME">callback</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">callback</span><span class="PUNC">||</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="PUNC">}</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>358</span> 		</span><span class="NAME">schema.exec</span><span class="PUNC">(</span><span class="NAME">sql.select</span><span class="PUNC">(</span><span class="NAME">fields</span><span class="PUNC">,</span><span class="NAME">where</span><span class="PUNC">,</span><span class="NAME">limit</span><span class="PUNC">,</span><span class="NAME">order</span><span class="PUNC">)</span><span class="PUNC">,</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>359</span> 			</span><span class="NAME">callback.apply</span><span class="PUNC">(</span><span class="KEYW">this</span><span class="PUNC">,</span><span class="PUNC">[</span><span class="NAME">this.success</span><span class="PUNC">]</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>360</span> 		</span><span class="PUNC">}</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>361</span> 		
<span class='line'>362</span> 	</span><span class="PUNC">}</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>363</span> 	</span><span class="COMM">/**
<span class='line'>364</span> 	 * Insert data
<span class='line'>365</span> 	 * @param {Map.&lt;String,mixed&gt;} data
<span class='line'>366</span> 	 * @param {AbstractSQL.Conflict} onConflict
<span class='line'>367</span> 	 * @param {Function} callback
<span class='line'>368</span> 	 */</span><span class="WHIT">
<span class='line'>369</span> 	</span><span class="NAME">insert</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">data</span><span class="PUNC">,</span><span class="NAME">onConflict</span><span class="PUNC">,</span><span class="NAME">callback</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>370</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">sql</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">AbstractSQL</span><span class="PUNC">(</span><span class="NAME">this.name</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>371</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">schema</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">this</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>372</span> 		</span><span class="NAME">callback</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">callback</span><span class="PUNC">||</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="PUNC">}</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>373</span> 		</span><span class="NAME">schema.exec</span><span class="PUNC">(</span><span class="NAME">sql.insert</span><span class="PUNC">(</span><span class="NAME">data</span><span class="PUNC">,</span><span class="NAME">onConflict</span><span class="PUNC">)</span><span class="PUNC">,</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>374</span> 			</span><span class="NAME">callback.apply</span><span class="PUNC">(</span><span class="KEYW">this</span><span class="PUNC">,</span><span class="PUNC">[</span><span class="NAME">this.success</span><span class="PUNC">]</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>375</span> 		</span><span class="PUNC">}</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>376</span> 		
<span class='line'>377</span> 	</span><span class="PUNC">}</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>378</span> 	</span><span class="COMM">/**
<span class='line'>379</span> 	 * Update rows
<span class='line'>380</span> 	 * @param {Map.&lt;String,String&gt;} data
<span class='line'>381</span> 	 * @param {AbstractSQL.Where|AbstractSQL.WhereList} where
<span class='line'>382</span> 	 * @param {AbstractSQL.Conflict} on conflict
<span class='line'>383</span> 	 * @param {Function} callback
<span class='line'>384</span> 	 */</span><span class="WHIT">
<span class='line'>385</span> 	</span><span class="NAME">update</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">data</span><span class="PUNC">,</span><span class="NAME">where</span><span class="PUNC">,</span><span class="NAME">onConflict</span><span class="PUNC">,</span><span class="NAME">callback</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>386</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">sql</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">AbstractSQL</span><span class="PUNC">(</span><span class="NAME">this.name</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>387</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">schema</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">this</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>388</span> 		</span><span class="NAME">callback</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">callback</span><span class="PUNC">||</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="PUNC">}</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>389</span> 		</span><span class="NAME">schema.exec</span><span class="PUNC">(</span><span class="NAME">sql.update</span><span class="PUNC">(</span><span class="NAME">data</span><span class="PUNC">,</span><span class="NAME">where</span><span class="PUNC">,</span><span class="NAME">onConflict</span><span class="PUNC">)</span><span class="PUNC">,</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>390</span> 			</span><span class="NAME">callback.apply</span><span class="PUNC">(</span><span class="KEYW">this</span><span class="PUNC">,</span><span class="PUNC">[</span><span class="NAME">this.success</span><span class="PUNC">]</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>391</span> 		</span><span class="PUNC">}</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>392</span> 	</span><span class="PUNC">}</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>393</span> 	</span><span class="COMM">/**
<span class='line'>394</span> 	 * Remove rows
<span class='line'>395</span> 	 * @param {AbstractSQL.Where|AbstractSQL.WhereList} where
<span class='line'>396</span> 	 * @param {Function} callback
<span class='line'>397</span> 	 */</span><span class="WHIT">
<span class='line'>398</span> 	</span><span class="NAME">remove</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">where</span><span class="PUNC">,</span><span class="NAME">callback</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>399</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">sql</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">AbstractSQL</span><span class="PUNC">(</span><span class="NAME">this.name</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>400</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">schema</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">this</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>401</span> 		</span><span class="NAME">callback</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">callback</span><span class="PUNC">||</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="PUNC">}</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>402</span> 		</span><span class="NAME">schema.exec</span><span class="PUNC">(</span><span class="NAME">sql.remove</span><span class="PUNC">(</span><span class="NAME">where</span><span class="PUNC">)</span><span class="PUNC">,</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>403</span> 			</span><span class="NAME">callback.apply</span><span class="PUNC">(</span><span class="KEYW">this</span><span class="PUNC">,</span><span class="PUNC">[</span><span class="NAME">this.success</span><span class="PUNC">]</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>404</span> 		</span><span class="PUNC">}</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>405</span> 	</span><span class="PUNC">}</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>406</span> 	</span><span class="COMM">/**
<span class='line'>407</span> 	 * Get rows size, first argument of callback is number.
<span class='line'>408</span> 	 * @param {AbstractSQL.Where} where
<span class='line'>409</span> 	 * @param {Function} callback
<span class='line'>410</span> 	 */</span><span class="WHIT">
<span class='line'>411</span> 	</span><span class="NAME">count</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">where</span><span class="PUNC">,</span><span class="NAME">callback</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>412</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">sql</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">AbstractSQL</span><span class="PUNC">(</span><span class="NAME">this.name</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>413</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">schema</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">this</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>414</span> 		</span><span class="KEYW">if</span><span class="PUNC">(</span><span class="KEYW">typeof</span><span class="WHIT"> </span><span class="NAME">where</span><span class="WHIT"> </span><span class="PUNC">==</span><span class="WHIT"> </span><span class="STRN">"function"</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>415</span> 			</span><span class="NAME">callback</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">where</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>416</span> 			</span><span class="NAME">where</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">null</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>417</span> 		</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>418</span> 		</span><span class="NAME">callback</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">callback</span><span class="PUNC">||</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="PUNC">}</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>419</span> 		</span><span class="NAME">schema.exec</span><span class="PUNC">(</span><span class="NAME">sql.count</span><span class="PUNC">(</span><span class="STRN">"*"</span><span class="PUNC">,</span><span class="NAME">where</span><span class="PUNC">)</span><span class="PUNC">,</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>420</span> 			</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">r</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="PUNC">!</span><span class="NAME">this.error</span><span class="PUNC">&&</span><span class="NAME">this.resultSet</span><span class="PUNC">?</span><span class="NAME">this.resultSet.rows</span><span class="PUNC">:</span><span class="KEYW">false</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>421</span> 			</span><span class="KEYW">if</span><span class="PUNC">(</span><span class="PUNC">!</span><span class="NAME">r</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="KEYW">return</span><span class="WHIT"> </span><span class="NAME">callback.apply</span><span class="PUNC">(</span><span class="KEYW">this</span><span class="PUNC">,</span><span class="PUNC">[</span><span class="PUNC">-</span><span class="NUMB">1</span><span class="PUNC">]</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>422</span> 			</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">o</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">r.item</span><span class="PUNC">(</span><span class="NUMB">0</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>423</span> 			</span><span class="KEYW">for</span><span class="PUNC">(</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">i</span><span class="WHIT"> </span><span class="KEYW">in</span><span class="WHIT"> </span><span class="NAME">o</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>424</span> 				</span><span class="KEYW">return</span><span class="WHIT"> </span><span class="NAME">callback.apply</span><span class="PUNC">(</span><span class="KEYW">this</span><span class="PUNC">,</span><span class="PUNC">[</span><span class="NAME">o</span><span class="PUNC">[</span><span class="NAME">i</span><span class="PUNC">]</span><span class="PUNC">]</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>425</span> 			</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>426</span> 		</span><span class="PUNC">}</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>427</span> 	</span><span class="PUNC">}</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>428</span> 	</span><span class="COMM">/**
<span class='line'>429</span> 	 * Drop table
<span class='line'>430</span> 	 * @param {Function} callback
<span class='line'>431</span> 	 */</span><span class="WHIT">
<span class='line'>432</span> 	</span><span class="NAME">drop</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="NAME">callback</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>433</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">sql</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">new</span><span class="WHIT"> </span><span class="NAME">AbstractSQL</span><span class="PUNC">(</span><span class="NAME">this.name</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>434</span> 		</span><span class="KEYW">var</span><span class="WHIT"> </span><span class="NAME">schema</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">this</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>435</span> 		</span><span class="NAME">callback</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="NAME">callback</span><span class="PUNC">||</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="PUNC">}</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>436</span> 		</span><span class="NAME">schema.exec</span><span class="PUNC">(</span><span class="NAME">sql.dropTable</span><span class="PUNC">(</span><span class="KEYW">true</span><span class="PUNC">)</span><span class="PUNC">,</span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>437</span> 			</span><span class="NAME">callback.apply</span><span class="PUNC">(</span><span class="KEYW">this</span><span class="PUNC">,</span><span class="PUNC">[</span><span class="PUNC">!</span><span class="NAME">this.error</span><span class="PUNC">]</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>438</span> 		</span><span class="PUNC">}</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT">
<span class='line'>439</span> 		
<span class='line'>440</span> 	</span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>441</span> </span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>442</span> 
<span class='line'>443</span> </span><span class="COMM">/**
<span class='line'>444</span>  * Called from only DBClass#select
<span class='line'>445</span>  * @constructor
<span class='line'>446</span>  * @param {SQLResultSet} resultSet
<span class='line'>447</span>  */</span><span class="WHIT">
<span class='line'>448</span> </span><span class="NAME">DBClass.Result</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>449</span> </span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>450</span> 
<span class='line'>451</span> </span><span class="COMM">/**
<span class='line'>452</span>  * @class
<span class='line'>453</span>  */</span><span class="WHIT">
<span class='line'>454</span> </span><span class="NAME">DBClass.Result.prototype</span><span class="WHIT"> </span><span class="PUNC">=</span><span class="WHIT"> </span><span class="PUNC">{</span><span class="WHIT">
<span class='line'>455</span> 	</span><span class="COMM">/** @private */</span><span class="WHIT">
<span class='line'>456</span> 	</span><span class="NAME">sql</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="STRN">""</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>457</span> 	</span><span class="COMM">/**
<span class='line'>458</span> 	 * @type Error
<span class='line'>459</span> 	 */</span><span class="WHIT">
<span class='line'>460</span> 	</span><span class="NAME">error</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">null</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>461</span> 	</span><span class="COMM">/**
<span class='line'>462</span> 	 * @type Boolean
<span class='line'>463</span> 	 */</span><span class="WHIT">
<span class='line'>464</span> 	</span><span class="NAME">success</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">false</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>465</span> 	</span><span class="COMM">/**
<span class='line'>466</span> 	 * @type int
<span class='line'>467</span> 	 */</span><span class="WHIT">
<span class='line'>468</span> 	</span><span class="NAME">length</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="NUMB">0</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>469</span> 	</span><span class="COMM">/**
<span class='line'>470</span> 	 * Called each items.
<span class='line'>471</span> 	 * @param {Function} func
<span class='line'>472</span> 	 */</span><span class="WHIT">
<span class='line'>473</span> 	</span><span class="NAME">each</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT"> </span><span class="KEYW">throw</span><span class="WHIT"> </span><span class="NAME">Error</span><span class="PUNC">(</span><span class="STRN">"DBClass.Result#each can use only result of select method."</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT"> </span><span class="PUNC">}</span><span class="PUNC">,</span><span class="WHIT">
<span class='line'>474</span> 	</span><span class="COMM">/**
<span class='line'>475</span> 	 * @param {int} idx
<span class='line'>476</span> 	 */</span><span class="WHIT">
<span class='line'>477</span> 	</span><span class="NAME">item</span><span class="WHIT"> </span><span class="PUNC">:</span><span class="WHIT"> </span><span class="KEYW">function</span><span class="PUNC">(</span><span class="PUNC">)</span><span class="PUNC">{</span><span class="WHIT"> </span><span class="KEYW">throw</span><span class="WHIT"> </span><span class="NAME">Error</span><span class="PUNC">(</span><span class="STRN">"DBClass.Result#item can use only result of select method."</span><span class="PUNC">)</span><span class="PUNC">;</span><span class="WHIT"> </span><span class="PUNC">}</span><span class="WHIT">
<span class='line'>478</span> </span><span class="PUNC">}</span></pre></body></html>